package com.wy.dao.music;

import com.domain.bean.music.Song;
import com.domain.bean.music.SongMenu;
import com.wy.dao.sys.BaseDAO;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * Created with IntelliJ IDEA.
 * Description:
 * Author : wangyu
 * Date: 2018-03-05
 * Time: 14:01
 */
public interface SongMenuDAO extends BaseDAO<SongMenu,Integer> {
    SongMenu findByCode(String code);

    @Query(value = "SELECT * FROM `music_song_menu` WHERE times = ?1 LIMIT 0,70000;" ,nativeQuery = true)
    List<SongMenu> selectLimt(int time);
}
